{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}L:\global vam\replication_psrm\replication.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}26 Apr 2019, 18:42:26

{com}. do "L:\global vam\replication_psrm\table1.do"
{txt}
{com}. *TABLE 1
. *Childcare
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synth`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table 1: Childcare pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .905536           0    .905536    .905536
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .905536           0    .905536    .905536
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8530846           0   .8530846   .8530846
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8840209           0   .8840209   .8840209
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6516777           0   .6516777   .6516777
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6243271           0   .6243271   .6243271
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7369191           0   .7369191   .7369191
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6697592           0   .6697592   .6697592
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8765693           0   .8765693   .8765693
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8621064           0   .8621064   .8621064
{txt}
{com}. 
. clear
{txt}
{com}. use "childcareoutput.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table 1: Childcare Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     1.90012    2.636067   .0645044   15.92826

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    1.898988    2.636127   .0645044   15.92826

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    1.903064    2.651272   .0739295   16.65422

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     1.92943    2.734653   .0595673   15.75191

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    1.880215    2.526945   .0258612   16.45465

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    1.869885    2.591751   .0702041   15.46359

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    2.073325    2.690416   .0836518   16.28356

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    2.278862    2.900127   .0900904   18.97493

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    1.874306    2.566602   .0560513   16.68722

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    2.123741    2.645802   .0373099    15.0899

{txt}
{com}. 
. *Table 1: Childcare p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .5609756           .   .5609756   .5609756
{txt}{space 5}p_Fla_2 {c |}{res}          1    .5609756           .   .5609756   .5609756
{txt}{space 5}p_Fla_3 {c |}{res}          1    .5487805           .   .5487805   .5487805
{txt}{space 5}p_Fla_4 {c |}{res}          1    .3719512           .   .3719512   .3719512
{txt}{space 5}p_Fla_5 {c |}{res}          1    .7073171           .   .7073171   .7073171
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .7073171           .   .7073171   .7073171
{txt}{space 5}p_Fla_7 {c |}{res}          1    .3719512           .   .3719512   .3719512
{txt}{space 5}p_Fla_8 {c |}{res}          1    .5731707           .   .5731707   .5731707
{txt}{space 5}p_Fla_9 {c |}{res}          1    .4939024           .   .4939024   .4939024
{txt}{space 4}p_Fla_10 {c |}{res}          1    .4756097           .   .4756097   .4756097
{txt}
{com}. 
. 
. *Education
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synthed`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table 1: Education pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9329103           0   .9329103   .9329103
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9329103           0   .9329103   .9329103
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9326593           0   .9326593   .9326593
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9288365           0   .9288365   .9288365
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7727617           0   .7727617   .7727617
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .0796054           0   .0796054   .0796054
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9272278           0   .9272278   .9272278
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9224825           0   .9224825   .9224825
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9309669           0   .9309669   .9309669
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .933263           0    .933263    .933263
{txt}
{com}. 
. clear
{txt}
{com}. use "educationoutput.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table 1: Education Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.24302    14.50845   .5515109    99.3924

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.24285    14.51356   .5515109    99.3924

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.45242    15.97643    .677548    132.944

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.25994    14.06113   .5907562   84.06635

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.21181    14.30555   .8984386   101.1246

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.42263    15.56446   .5817356   111.9156

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.95297    15.54493    .285175   108.7389

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.75598    14.29843   .7045293   98.68465

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    15.01793     14.7491   .4972603   99.84814

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     15.5596     14.5668    .354978    99.3924

{txt}
{com}. 
. *Table 1: Education p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .1646342           .   .1646342   .1646342
{txt}{space 5}p_Fla_2 {c |}{res}          1    .1646342           .   .1646342   .1646342
{txt}{space 5}p_Fla_3 {c |}{res}          1    .0182927           .   .0182927   .0182927
{txt}{space 5}p_Fla_4 {c |}{res}          1    .0060976           .   .0060976   .0060976
{txt}{space 5}p_Fla_5 {c |}{res}          1    .3170732           .   .3170732   .3170732
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .9329268           .   .9329268   .9329268
{txt}{space 5}p_Fla_7 {c |}{res}          1    .0365854           .   .0365854   .0365854
{txt}{space 5}p_Fla_8 {c |}{res}          1    .0121951           .   .0121951   .0121951
{txt}{space 5}p_Fla_9 {c |}{res}          1    .0853659           .   .0853659   .0853659
{txt}{space 4}p_Fla_10 {c |}{res}          1    .0914634           .   .0914634   .0914634
{txt}
{com}. 
. 
. 
. *Elderlycare
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synthel`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table 1: Elderlycare pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .875414           0    .875414    .875414
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .875414           0    .875414    .875414
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7052019           0   .7052019   .7052019
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6251953           0   .6251953   .6251953
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6836095           0   .6836095   .6836095
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .4962473           0   .4962473   .4962473
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7962663           0   .7962663   .7962663
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .807411           0    .807411    .807411
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8711455           0   .8711455   .8711455
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8713317           0   .8713317   .8713317
{txt}
{com}. 
. clear
{txt}
{com}. use "elderlyoutput.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table 1: Elderlycare Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    24.10171    31.17134   .6162773   276.4507

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    24.11422    31.17361   .6162773   276.4507

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    24.68853    32.89312   1.004557    285.384

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    24.88554    33.60333   1.191246   290.8822

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    24.27119    29.88958     .60903   220.4217

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    23.77786    28.72456   1.462896   235.9222

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    24.80909    30.05472    .465128    197.114

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    30.00753    42.93631   1.851903   377.0193

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     24.0152     29.0324   .2042605   234.8499

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    26.48079    33.00819   .9102527   279.1628

{txt}
{com}. 
. *Table 1: Elderlycare p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .8231707           .   .8231707   .8231707
{txt}{space 5}p_Fla_2 {c |}{res}          1    .8231707           .   .8231707   .8231707
{txt}{space 5}p_Fla_3 {c |}{res}          1    .9146342           .   .9146342   .9146342
{txt}{space 5}p_Fla_4 {c |}{res}          1    .9329268           .   .9329268   .9329268
{txt}{space 5}p_Fla_5 {c |}{res}          1    .7317073           .   .7317073   .7317073
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .8536586           .   .8536586   .8536586
{txt}{space 5}p_Fla_7 {c |}{res}          1    .7987805           .   .7987805   .7987805
{txt}{space 5}p_Fla_8 {c |}{res}          1    .7560976           .   .7560976   .7560976
{txt}{space 5}p_Fla_9 {c |}{res}          1    .8292683           .   .8292683   .8292683
{txt}{space 4}p_Fla_10 {c |}{res}          1    .8109756           .   .8109756   .8109756
{txt}
{com}. 
. 
. 
. *Healthcare
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synthhe`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table 1: Healthcare pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9354807           0   .9354807   .9354807
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9354807           0   .9354807   .9354807
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7990956           0   .7990956   .7990956
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .5173472           0   .5173472   .5173472
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8449362           0   .8449362   .8449362
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8115575           0   .8115575   .8115575
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9348707           0   .9348707   .9348707
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9348707           0   .9348707   .9348707
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9348707           0   .9348707   .9348707
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .934867           0    .934867    .934867
{txt}
{com}. 
. clear
{txt}
{com}. use "healthoutput.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table 1: Healthcare Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.504659    15.23811   .1105251   157.8669

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.506035    15.23841   .1105251   157.8669

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.024558    13.30277   .1065145   133.5887

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.377383    13.70667    .129423   139.1857

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.293553    13.62711   .2337688    135.513

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     6.89544     14.7869   .1864998   136.9072

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    7.735147    18.11601   .1988242   145.6491

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    8.536076    18.97577   .2634757   150.8422

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.557898    14.72487   .1521035   146.2237

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    6.933923    15.37559   .1692586   149.0509

{txt}
{com}. 
. *Table 1: Healthcare p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1          .5           .         .5         .5
{txt}{space 5}p_Fla_2 {c |}{res}          1          .5           .         .5         .5
{txt}{space 5}p_Fla_3 {c |}{res}          1    .7256098           .   .7256098   .7256098
{txt}{space 5}p_Fla_4 {c |}{res}          1    .7743902           .   .7743902   .7743902
{txt}{space 5}p_Fla_5 {c |}{res}          1    .5792683           .   .5792683   .5792683
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .4634146           .   .4634146   .4634146
{txt}{space 5}p_Fla_7 {c |}{res}          1    .3048781           .   .3048781   .3048781
{txt}{space 5}p_Fla_8 {c |}{res}          1    .2073171           .   .2073171   .2073171
{txt}{space 5}p_Fla_9 {c |}{res}          1    .4512195           .   .4512195   .4512195
{txt}{space 4}p_Fla_10 {c |}{res}          1    .4207317           .   .4207317   .4207317
{txt}
{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\table2.do"
{txt}
{com}. *TABLE 2
. *PANEL A
. *Childcare
. use synth9_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    4.719349    .5709028   3.914591   5.518672
{txt}_Y_synthetic {c |}{res}          5    5.234204    .5908996   4.608595   6.137066
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 9 in Table 1 (see table1.do)
. 
. *Education
. use synthed9_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    20.22806    1.597905   18.56896   22.79359
{txt}_Y_synthetic {c |}{res}          5    23.22493    4.539767   18.25078   28.26171
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 9 in Table 1 (see table1.do)
. 
. *Elderlycare
. use synthel9_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    31.33533    2.650114   26.72598   33.15353
{txt}_Y_synthetic {c |}{res}          5    31.94119    2.968575   28.83115   36.68919
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 9 in Table 1 (see table1.do)
. 
. *Health care
. use synthhe3_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    8.947246     1.95796   7.099644   12.17842
{txt}_Y_synthetic {c |}{res}          5    7.845242    1.146939   6.799723   9.789534
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 3 in Table 1 (see table1.do)
. 
. 
. *PANEL B
. *Childcare
. use synth1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 3 4 9 10{c -(}
{txt}  2{com}. append using synth`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    4.719349    .5709028   3.914591   5.518672
{txt}_Y_synthetic {c |}{res}          5    5.464888    .3906201   4.884989   5.944218
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "childcare_avg_p.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .5304878           .   .5304878   .5304878
{txt}
{com}. 
. *Education
. use synthed1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 3  5 6 7 8  9 10{c -(}
{txt}  2{com}. append using synthed`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    20.22806    1.597905   18.56896   22.79359
{txt}_Y_synthetic {c |}{res}          5    22.83455    4.023274   18.43464     27.277
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "education_avg_p.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .1097561           .   .1097561   .1097561
{txt}
{com}. 
. 
. *Elderlycare
. use synthel1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 7 8 9 10{c -(}
{txt}  2{com}. append using synthel`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    31.33533    2.650114   26.72598   33.15353
{txt}_Y_synthetic {c |}{res}          5    31.90505    2.778622   28.77353   36.09584
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "elderly_avg_p.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1     .847561           .    .847561    .847561
{txt}
{com}. 
. 
. *Health care
. use synthhe1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 3  5 6 7 8  9 10{c -(}
{txt}  2{com}. append using synthhe`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 & _time<2001

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}          5    8.947246     1.95796   7.099644   12.17842
{txt}_Y_synthetic {c |}{res}          5    8.138204    .7317086     7.4134   9.029586
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "health_avg_p.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .4451219           .   .4451219   .4451219
{txt}
{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\figure1.do"
{txt}
{com}. *THIS FILE CONSTRUCTS FIGURE 1 IN THE PAPER.
. clear
{txt}
{com}. use figure1.dta
{txt}
{com}. 
. twoway (line VoteShareDNA year if fla==1, title("Vote share Ap (local elections)") ytitle("Vote share Ap") legend(order(1 2) label(1 "Flå" )region(lwidth(none))) xtitle("Year") color(black) graphr(color(white)) plotregion(style(none)))(line mvote_ap year,color(black) lp(dash)legend(order(1 2) label(2 "Rest of Norway" )region(lwidth(none)))) (scatteri 0 1995 .6 1995,  c(l) lp(dash_dot ) lw(thin) m(i)legend(order(1 2) region(lwidth(none))))
{res}{txt}
{com}. graph save Graph "ap_local.gph", replace
{res}{txt}(file ap_local.gph saved)

{com}. graph export "ap_local.pdf", as(pdf) replace
{txt}(file ap_local.pdf written in PDF format)

{com}. 
. twoway (line l2VoteNatDNA year if fla==1, title("Vote share Ap (national elections)") ytitle("Vote share Ap") legend(order(1 2) label(1 "Flå" )region(lwidth(none))) xtitle("Year") color(black) graphr(color(white)) plotregion(style(none)))(line ml2votenat_ap year,color(black) lp(dash)legend(order(1 2) label(2 "Rest of Norway" )region(lwidth(none)))) (scatteri 0 1995 .6 1995,  c(l) lp(dash_dot ) lw(thin) m(i)legend(order(1 2) region(lwidth(none))))
{res}{txt}
{com}. graph save Graph "ap_national.gph", replace
{res}{txt}(file ap_national.gph saved)

{com}. graph export "ap_national.pdf", as(pdf) replace
{txt}(file ap_national.pdf written in PDF format)

{com}. 
. graph combine "ap_local.gph" "ap_national.gph"
{res}{txt}
{com}. graph export "ap_figs.pdf", as(pdf) replace
{txt}(file ap_figs.pdf written in PDF format)

{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\figure2.do"
{txt}
{com}. 
. *FIGURE 2
. 
. use synth3_615.dta, clear
{txt}
{com}. graph twoway (line _Y_treated _time, title("Child care") ytitle("Share child care") legend(order(1 2) label(1 "Flå" )region(lwidth(none))) xtitle("Year") color(black) graphr(color(white)) plotregion(style(none)))(line _Y_synthetic _time,color(black) lp(dash)legend(order(1 2) label(2 "Synthetic control unit" )region(lwidth(none)))) (scatteri 0 1995 10 1995,  c(l) lp(dash_dot ) lw(thin) m(i)legend(order(1 2) region(lwidth(none))))
{res}{txt}
{com}. graph save Graph "childcare.gph", replace
{res}{txt}(file childcare.gph saved)

{com}. graph export "childcare.pdf", as(pdf) replace
{txt}(file childcare.pdf written in PDF format)

{com}. 
. use synthed9_615.dta, clear
{txt}
{com}. graph twoway (line _Y_treated _time, title("Education") ytitle("Share Education") legend(order(1 2) label(1 "Flå" )region(lwidth(none))) xtitle("Year") color(black) graphr(color(white)) plotregion(style(none)))(line _Y_synthetic _time,color(black) lp(dash)legend(order(1 2) label(2 "Synthetic control unit" )region(lwidth(none)))) (scatteri 0 1995 40 1995,  c(l) lp(dash_dot ) lw(thin) m(i)legend(order(1 2) region(lwidth(none))))
{res}{txt}
{com}. graph save Graph "education.gph", replace
{res}{txt}(file education.gph saved)

{com}. graph export "education.pdf", as(pdf) replace
{txt}(file education.pdf written in PDF format)

{com}. 
. use synthel9_615.dta, clear
{txt}
{com}. graph twoway (line _Y_treated _time, title("Elderlycare") ytitle("Share Elderlycare") legend(order(1 2) label(1 "Flå" )region(lwidth(none))) xtitle("Year") color(black) graphr(color(white)) plotregion(style(none)))(line _Y_synthetic _time,color(black) lp(dash)legend(order(1 2) label(2 "Synthetic control unit" )region(lwidth(none)))) (scatteri 0 1995 40 1995,  c(l) lp(dash_dot ) lw(thin) m(i)legend(order(1 2) region(lwidth(none))))
{res}{txt}
{com}. graph save Graph "elderly.gph", replace
{res}{txt}(file elderly.gph saved)

{com}. graph export "elderly.pdf", as(pdf) replace
{txt}(file elderly.pdf written in PDF format)

{com}. 
. use synthhe3_615.dta, clear
{txt}
{com}. graph twoway (line _Y_treated _time, title("Health care") ytitle("Share health care") legend(order(1 2) label(1 "Flå" )region(lwidth(none))) xtitle("Year") color(black) graphr(color(white)) plotregion(style(none)))(line _Y_synthetic _time,color(black) lp(dash)legend(order(1 2) label(2 "Synthetic control unit" )region(lwidth(none)))) (scatteri 0 1995 20 1995,  c(l) lp(dash_dot ) lw(thin) m(i)legend(order(1 2) region(lwidth(none))))
{res}{txt}
{com}. graph save Graph "health.gph", replace
{res}{txt}(file health.gph saved)

{com}. graph export "health.pdf", as(pdf) replace
{txt}(file health.pdf written in PDF format)

{com}. 
. graph combine "childcare.gph" "education.gph" "elderly.gph" "health.gph", c(2) r(2)
{res}{txt}
{com}. graph save Graph "treat_comb.gph", replace
{res}{txt}(file treat_comb.gph saved)

{com}. graph export "treat_comb.pdf", as(pdf) replace
{txt}(file treat_comb.pdf written in PDF format)

{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\figure3.do"
{txt}
{com}. 
. *FIGURE 3
. clear
{txt}
{com}. use "childcare_model3.dta"
{txt}
{com}. gen gap =  _Y_treated - _Y_synthetic
{txt}
{com}. gen Year = _time
{txt}
{com}. gen fla = 1 if komnr==615
{txt}(5,248 missing values generated)

{com}. qui su gap, detail
{txt}
{com}. local gapmin = r(min)
{txt}
{com}. local gapmax = r(max)
{txt}
{com}. qui su Year, detail
{txt}
{com}. local yearmin = r(min)
{txt}
{com}. local yearmax = r(max)
{txt}
{com}. levelsof komnr, local(levels)
{res}{txt}121 428 430 432 434 437 438 439 511 512 513 514 515 517 540 541 542 543 544 545 615 616 617 618 619 620 621 633 821 826 828 829 830 831 833 834 929 938 940 941 1003 1026 1034 1046 1133 1134 1135 1144 1151 1211 1223 1224 1227 1233 1234 1238 1244 1252 1264 1265 1266 1411 1412 1413 1416 1418 1420 1421 1424 1426 1438 1439 1441 1515 1524 1525 1539 1545 1546 1560 1563 1566 1567 1573 1612 1617 1620 1621 1627 1630 1632 1633 1634 1635 1640 1644 1665 1711 1717 1718 1736 1738 1739 1740 1742 1743 1748 1749 1750 1751 1755 1811 1815 1816 1818 1825 1826 1827 1828 1834 1835 1836 1837 1838 1839 1848 1849 1850 1851 1853 1854 1856 1857 1860 1866 1867 1868 1870 1871 1917 1919 1922 1924 1925 1926 1927 1929 1931 1933 1939 1943 2002 2011 2015 2017 2020 2021 2022 2023 2024 2025 2027 2028 2030

{com}. foreach l of local levels {c -(}
{txt}  2{com}.         local gr `gr' line gap Year if komnr == `l' & komnr!=615, color(gs10)   ||
{txt}  3{com}.         {c )-}
{txt}
{com}.         local gr `gr' line gap Year if fla == 1, color(black) c(L)  lw(thick)|| 
{txt}
{com}. graph twoway   `gr' ,  ytitle("Gap child care") legend(off) graphr(color(white)) plotregion(style(none))|| scatteri `gapmin' 1995 `gapmax' 1995,  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off) || scatteri  0 `yearmin'  0 `yearmax',  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off)
{res}{txt}
{com}.  graph save Graph "placebo_childcare.gph", replace
{res}{txt}(file placebo_childcare.gph saved)

{com}. graph export "placebo_childcare.pdf", as(pdf) replace
{txt}(file placebo_childcare.pdf written in PDF format)

{com}. 
. clear
{txt}
{com}. use "education_model9.dta"
{txt}
{com}. gen gap =  _Y_treated - _Y_synthetic
{txt}
{com}. gen Year = _time
{txt}
{com}. gen fla = 1 if komnr==615
{txt}(5,248 missing values generated)

{com}. qui su gap, detail
{txt}
{com}. local gapmin = r(min)
{txt}
{com}. local gapmax = r(max)
{txt}
{com}. qui su Year, detail
{txt}
{com}. local yearmin = r(min)
{txt}
{com}. local yearmax = r(max)
{txt}
{com}. levelsof komnr, local(levels)
{res}{txt}121 428 430 432 434 437 438 439 511 512 513 514 515 517 540 541 542 543 544 545 615 616 617 618 619 620 621 633 821 826 828 829 830 831 833 834 929 938 940 941 1003 1026 1034 1046 1133 1134 1135 1144 1151 1211 1223 1224 1227 1233 1234 1238 1244 1252 1264 1265 1266 1411 1412 1413 1416 1418 1420 1421 1424 1426 1438 1439 1441 1515 1524 1525 1539 1545 1546 1560 1563 1566 1567 1573 1612 1617 1620 1621 1627 1630 1632 1633 1634 1635 1640 1644 1665 1711 1717 1718 1736 1738 1739 1740 1742 1743 1748 1749 1750 1751 1755 1811 1815 1816 1818 1825 1826 1827 1828 1834 1835 1836 1837 1838 1839 1848 1849 1850 1851 1853 1854 1856 1857 1860 1866 1867 1868 1870 1871 1917 1919 1922 1924 1925 1926 1927 1929 1931 1933 1939 1943 2002 2011 2015 2017 2020 2021 2022 2023 2024 2025 2027 2028 2030

{com}. foreach l of local levels {c -(}
{txt}  2{com}.         local gr `gr' line gap Year if komnr == `l' & komnr!=615, color(gs10)   ||
{txt}  3{com}.         {c )-}
{txt}
{com}.         local gr `gr' line gap Year if fla == 1, color(black) c(L)  lw(thick)|| 
{txt}
{com}. graph twoway   `gr' ,  ytitle("Gap education") legend(off) graphr(color(white)) plotregion(style(none))|| scatteri `gapmin' 1995 `gapmax' 1995,  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off) || scatteri  0 `yearmin'  0 `yearmax',  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off)
{res}{txt}
{com}. graph save Graph "placebo_education.gph", replace
{res}{txt}(file placebo_education.gph saved)

{com}. graph export "placebo_education.pdf", as(pdf) replace
{txt}(file placebo_education.pdf written in PDF format)

{com}. 
. clear
{txt}
{com}. use "elderly_model9.dta"
{txt}
{com}. gen gap =  _Y_treated - _Y_synthetic
{txt}
{com}. gen Year = _time
{txt}
{com}. gen fla = 1 if komnr==615
{txt}(5,248 missing values generated)

{com}. qui su gap, detail
{txt}
{com}. local gapmin = r(min)
{txt}
{com}. local gapmax = r(max)
{txt}
{com}. qui su Year, detail
{txt}
{com}. local yearmin = r(min)
{txt}
{com}. local yearmax = r(max)
{txt}
{com}. levelsof komnr, local(levels)
{res}{txt}121 428 430 432 434 437 438 439 511 512 513 514 515 517 540 541 542 543 544 545 615 616 617 618 619 620 621 633 821 826 828 829 830 831 833 834 929 938 940 941 1003 1026 1034 1046 1133 1134 1135 1144 1151 1211 1223 1224 1227 1233 1234 1238 1244 1252 1264 1265 1266 1411 1412 1413 1416 1418 1420 1421 1424 1426 1438 1439 1441 1515 1524 1525 1539 1545 1546 1560 1563 1566 1567 1573 1612 1617 1620 1621 1627 1630 1632 1633 1634 1635 1640 1644 1665 1711 1717 1718 1736 1738 1739 1740 1742 1743 1748 1749 1750 1751 1755 1811 1815 1816 1818 1825 1826 1827 1828 1834 1835 1836 1837 1838 1839 1848 1849 1850 1851 1853 1854 1856 1857 1860 1866 1867 1868 1870 1871 1917 1919 1922 1924 1925 1926 1927 1929 1931 1933 1939 1943 2002 2011 2015 2017 2020 2021 2022 2023 2024 2025 2027 2028 2030

{com}. foreach l of local levels {c -(}
{txt}  2{com}.         local gr `gr' line gap Year if komnr == `l' & komnr!=615, color(gs10)   ||
{txt}  3{com}.         {c )-}
{txt}
{com}.         local gr `gr' line gap Year if fla == 1, color(black) c(L)  lw(thick)|| 
{txt}
{com}. graph twoway   `gr' ,  ytitle("Gap elderlycare") legend(off) graphr(color(white)) plotregion(style(none))|| scatteri `gapmin' 1995 `gapmax' 1995,  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off) || scatteri  0 `yearmin'  0 `yearmax',  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off)
{res}{txt}
{com}.  graph save Graph "placebo_elderlycare.gph", replace
{res}{txt}(file placebo_elderlycare.gph saved)

{com}. graph export "placebo_elderlycare.pdf", as(pdf) replace
{txt}(file placebo_elderlycare.pdf written in PDF format)

{com}. 
. clear
{txt}
{com}. use "health_model3.dta"
{txt}
{com}. gen gap =  _Y_treated - _Y_synthetic
{txt}
{com}. gen Year = _time
{txt}
{com}. gen fla = 1 if komnr==615
{txt}(5,248 missing values generated)

{com}. qui su gap, detail
{txt}
{com}. local gapmin = r(min)
{txt}
{com}. local gapmax = r(max)
{txt}
{com}. qui su Year, detail
{txt}
{com}. local yearmin = r(min)
{txt}
{com}. local yearmax = r(max)
{txt}
{com}. levelsof komnr, local(levels)
{res}{txt}121 428 430 432 434 437 438 439 511 512 513 514 515 517 540 541 542 543 544 545 615 616 617 618 619 620 621 633 821 826 828 829 830 831 833 834 929 938 940 941 1003 1026 1034 1046 1133 1134 1135 1144 1151 1211 1223 1224 1227 1233 1234 1238 1244 1252 1264 1265 1266 1411 1412 1413 1416 1418 1420 1421 1424 1426 1438 1439 1441 1515 1524 1525 1539 1545 1546 1560 1563 1566 1567 1573 1612 1617 1620 1621 1627 1630 1632 1633 1634 1635 1640 1644 1665 1711 1717 1718 1736 1738 1739 1740 1742 1743 1748 1749 1750 1751 1755 1811 1815 1816 1818 1825 1826 1827 1828 1834 1835 1836 1837 1838 1839 1848 1849 1850 1851 1853 1854 1856 1857 1860 1866 1867 1868 1870 1871 1917 1919 1922 1924 1925 1926 1927 1929 1931 1933 1939 1943 2002 2011 2015 2017 2020 2021 2022 2023 2024 2025 2027 2028 2030

{com}. foreach l of local levels {c -(}
{txt}  2{com}.         local gr `gr' line gap Year if komnr == `l' & komnr!=615, color(gs10)   ||
{txt}  3{com}.         {c )-}
{txt}
{com}.         local gr `gr' line gap Year if fla == 1, color(black) c(L)  lw(thick)|| 
{txt}
{com}. graph twoway   `gr' ,  ytitle("Gap healthcare") legend(off) graphr(color(white)) plotregion(style(none))|| scatteri `gapmin' 1995 `gapmax' 1995,  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off) || scatteri  0 `yearmin'  0 `yearmax',  c(l) color(black) lp(dash_dot ) lw(thin) m(i)legend(off)
{res}{txt}
{com}.  graph save Graph "placebo_healthcare.gph", replace
{res}{txt}(file placebo_healthcare.gph saved)

{com}. graph export "placebo_healthcare.pdf", as(pdf) replace
{txt}(file placebo_healthcare.pdf written in PDF format)

{com}. 
. 
. graph combine "placebo_childcare.gph" "placebo_education.gph" "placebo_elderlycare.gph" "placebo_healthcare.gph", c(2) r(2)
{res}{txt}
{com}. graph save Graph "placebo_comb.gph", replace
{res}{txt}(file placebo_comb.gph saved)

{com}. graph export "placebo_comb.pdf", as(pdf) replace
{txt}(file placebo_comb.pdf written in PDF format)

{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\tablea1.do"
{txt}
{com}. *TABLE A1
. clear
{txt}
{com}. use "tablea1.dta"
{txt}
{com}. *Table A1 first column
. su  matters matters_for_me not_adm_rule if small_munic==1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}matters {c |}{res}        834    .5479616     .497993          0          1
{txt}matters_fo~e {c |}{res}        844    .5853081    .4929609          0          1
{txt}not_adm_rule {c |}{res}        786    .3371501    .4730376          0          1
{txt}
{com}. *Table A1 second column
. su  matters matters_for_me not_adm_rule if small_munic==0

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}matters {c |}{res}      2,844    .6360759    .4812118          0          1
{txt}matters_fo~e {c |}{res}      2,878    .5639333    .4959819          0          1
{txt}not_adm_rule {c |}{res}      2,683    .3317182    .4709181          0          1
{txt}
{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\tablea2.do"
{txt}
{com}. *TABLE A2
. *Childcare
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synth`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table A2: Childcare pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .905536           0    .905536    .905536
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .905536           0    .905536    .905536
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8530846           0   .8530846   .8530846
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8840209           0   .8840209   .8840209
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6516777           0   .6516777   .6516777
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6243271           0   .6243271   .6243271
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7369191           0   .7369191   .7369191
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6697592           0   .6697592   .6697592
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8765693           0   .8765693   .8765693
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8621064           0   .8621064   .8621064
{txt}
{com}. 
. clear
{txt}
{com}. use "childcareoutput_long.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table A2: Childcare Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.450505    3.304964   .2713558   20.28524

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.452865    3.304999   .2713558   20.28524

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     3.10886    2.622122   .2793517   14.91365

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.525691    3.324173   .2793517   20.48554

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.161216    3.085106   .2844647    19.6453

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.427946    3.179191   .2824442   20.35978

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.304787    3.036922   .5158816   18.26481

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.695547    3.495733    .209951   21.72359

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.207639    2.921569   .2592907   17.82825

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    3.456702    3.119501   .2027682   19.15488

{txt}
{com}. 
. *Table A2: Childcare p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .4268293           .   .4268293   .4268293
{txt}{space 5}p_Fla_2 {c |}{res}          1    .4268293           .   .4268293   .4268293
{txt}{space 5}p_Fla_3 {c |}{res}          1    .5609756           .   .5609756   .5609756
{txt}{space 5}p_Fla_4 {c |}{res}          1    .2134146           .   .2134146   .2134146
{txt}{space 5}p_Fla_5 {c |}{res}          1    .7987805           .   .7987805   .7987805
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .6951219           .   .6951219   .6951219
{txt}{space 5}p_Fla_7 {c |}{res}          1    .5548781           .   .5548781   .5548781
{txt}{space 5}p_Fla_8 {c |}{res}          1          .5           .         .5         .5
{txt}{space 5}p_Fla_9 {c |}{res}          1    .4329268           .   .4329268   .4329268
{txt}{space 4}p_Fla_10 {c |}{res}          1    .3231707           .   .3231707   .3231707
{txt}
{com}. 
. 
. *Education
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synthed`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table A2: Education pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9329103           0   .9329103   .9329103
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9329103           0   .9329103   .9329103
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9326593           0   .9326593   .9326593
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9288365           0   .9288365   .9288365
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7727617           0   .7727617   .7727617
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .0796054           0   .0796054   .0796054
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9272278           0   .9272278   .9272278
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9224825           0   .9224825   .9224825
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9309669           0   .9309669   .9309669
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .933263           0    .933263    .933263
{txt}
{com}. 
. clear
{txt}
{com}. use "educationoutput_long.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table A2: Education Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    21.39588     16.6591   2.655608   121.8357

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    21.39629    16.65854   2.655608   121.8357

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    20.68225    16.68122   2.470499   121.8357

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    21.38857    16.45081   1.934293   121.8357

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     20.7862    16.12723   2.650246   125.5034

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    21.25109    16.08893   2.712416    119.802

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    21.35692    16.92282   2.078738   128.0209

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    22.50112    18.09632   2.788006   127.8896

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    20.55467    16.66487   2.312398   121.8357

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    22.20939    17.51001   2.009093   121.6839

{txt}
{com}. 
. *Table A2: Education p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .3109756           .   .3109756   .3109756
{txt}{space 5}p_Fla_2 {c |}{res}          1    .3109756           .   .3109756   .3109756
{txt}{space 5}p_Fla_3 {c |}{res}          1    .1402439           .   .1402439   .1402439
{txt}{space 5}p_Fla_4 {c |}{res}          1    .0792683           .   .0792683   .0792683
{txt}{space 5}p_Fla_5 {c |}{res}          1    .4756097           .   .4756097   .4756097
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .4146341           .   .4146341   .4146341
{txt}{space 5}p_Fla_7 {c |}{res}          1    .1829268           .   .1829268   .1829268
{txt}{space 5}p_Fla_8 {c |}{res}          1    .1158537           .   .1158537   .1158537
{txt}{space 5}p_Fla_9 {c |}{res}          1    .2560976           .   .2560976   .2560976
{txt}{space 4}p_Fla_10 {c |}{res}          1    .2682927           .   .2682927   .2682927
{txt}
{com}. 
. 
. 
. *Elderlycare
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synthel`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table A2: Elderlycare pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .875414           0    .875414    .875414
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .875414           0    .875414    .875414
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7052019           0   .7052019   .7052019
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6251953           0   .6251953   .6251953
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .6836095           0   .6836095   .6836095
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .4962473           0   .4962473   .4962473
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7962663           0   .7962663   .7962663
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .807411           0    .807411    .807411
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8711455           0   .8711455   .8711455
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8713317           0   .8713317   .8713317
{txt}
{com}. 
. clear
{txt}
{com}. use "elderlyoutput_long.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table A2: Elderlycare Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.26949    33.99569   4.300597   368.7177

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.25894    34.00136   4.270854   368.7177

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.21145    32.47419   3.703604   353.6925

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.90423    35.39917   3.749721   378.3983

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    28.93994    29.88827    3.30105   303.1586

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.07525    34.32313   4.283218   357.5864

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.60464    31.17088   4.886156   280.9888

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    34.27694    37.60298   4.335891   274.8608

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    29.11275    30.36587   3.601737   305.9192

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    32.76486    36.21309   2.834947   361.5021

{txt}
{com}. 
. *Table A2: Elderlycare p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .4939024           .   .4939024   .4939024
{txt}{space 5}p_Fla_2 {c |}{res}          1    .4939024           .   .4939024   .4939024
{txt}{space 5}p_Fla_3 {c |}{res}          1    .7621951           .   .7621951   .7621951
{txt}{space 5}p_Fla_4 {c |}{res}          1    .6585366           .   .6585366   .6585366
{txt}{space 5}p_Fla_5 {c |}{res}          1    .5182927           .   .5182927   .5182927
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .7012195           .   .7012195   .7012195
{txt}{space 5}p_Fla_7 {c |}{res}          1    .4695122           .   .4695122   .4695122
{txt}{space 5}p_Fla_8 {c |}{res}          1    .2682927           .   .2682927   .2682927
{txt}{space 5}p_Fla_9 {c |}{res}          1    .4634146           .   .4634146   .4634146
{txt}{space 4}p_Fla_10 {c |}{res}          1    .3658537           .   .3658537   .3658537
{txt}
{com}. 
. 
. 
. *Healthcare
. 
. clear
{txt}
{com}. foreach t of numlist 1 2 3 4 5 6 7 8 9 10 {c -(}
{txt}  2{com}. use synthhe`t'_615.dta, clear
{txt}  3{com}. drop _Co_Number _W_Weight
{txt}  4{com}. gen pre = 1 if _time<1996
{txt}  5{com}. keep if pre==1
{txt}  6{com}. gen spe  = (_Y_treated - _Y_synthetic)^2
{txt}  7{com}. egen m_y_treted = mean(_Y_treated )
{txt}  8{com}. gen sqdmean = (_Y_treated - m_y_treted)^2
{txt}  9{com}. egen numerator = sum(spe)
{txt} 10{com}. egen denominator = sum(sqdmean)
{txt} 11{com}. gen rsq = 1- (numerator/denominator)
{txt} 12{com}. *Table A2: Healthcare pre-r2: Means in the following output
. su rsq
{txt} 13{com}. {c )-}
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9354807           0   .9354807   .9354807
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9354807           0   .9354807   .9354807
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .7990956           0   .7990956   .7990956
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .5173472           0   .5173472   .5173472
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8449362           0   .8449362   .8449362
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .8115575           0   .8115575   .8115575
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9348707           0   .9348707   .9348707
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9348707           0   .9348707   .9348707
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16    .9348707           0   .9348707   .9348707
{txt}(147 missing values generated)
(147 observations deleted)

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 9}rsq {c |}{res}         16     .934867           0    .934867    .934867
{txt}
{com}. 
. clear
{txt}
{com}. use "healthoutput_long.dta"
{txt}
{com}. 
. foreach t of numlist 1 2 3 4 5 6 7 8 9 10{c -(}
{txt}  2{com}. sort komnr model
{txt}  3{com}. qui su RMSPE if komnr==615 & model==`t'
{txt}  4{com}. gen RMSPE_Fla_`t' = r(mean)
{txt}  5{com}. egen rank_RMSPE_`t' = rank(-RMSPE) if model==`t'
{txt}  6{com}. gen rank_RMSPE_Fla_`t'=rank_RMSPE_`t' if komnr==615 & model==`t'
{txt}  7{com}. gen p_Fla_`t' = rank_RMSPE_Fla_`t'/164
{txt}  8{com}. {c )-}
{txt}(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)
(1476 missing values generated)
(1,639 missing values generated)
(1,639 missing values generated)

{com}. 
. *Table A2: Healthcare Post MSPE column: Means in the following output
. bys model: su postmspe if komnr!=615

{txt}{hline}
-> model = 1

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.57622    10.54163   1.307296    59.1504

{txt}{hline}
-> model = 2

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     10.5774    10.54142   1.307296    59.1504

{txt}{hline}
-> model = 3

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.18061    9.791328   1.117279   56.95049

{txt}{hline}
-> model = 4

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.23391    9.773638   1.354855   59.18806

{txt}{hline}
-> model = 5

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163     10.5137    10.01679   1.477631   50.89338

{txt}{hline}
-> model = 6

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.44173    9.654682   1.254379   50.76542

{txt}{hline}
-> model = 7

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.97679    10.37965   1.334351   51.77506

{txt}{hline}
-> model = 8

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    11.22673    10.71299   1.249293    54.0421

{txt}{hline}
-> model = 9

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.41366    10.36928   .9966429   58.12307

{txt}{hline}
-> model = 10

    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}postmspe {c |}{res}        163    10.67012    10.39345   1.022803    60.7892

{txt}
{com}. 
. *Table A2: Healthcare p-value column: Means in the following output
. su p_Fla_*

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}p_Fla_1 {c |}{res}          1    .5548781           .   .5548781   .5548781
{txt}{space 5}p_Fla_2 {c |}{res}          1    .5548781           .   .5548781   .5548781
{txt}{space 5}p_Fla_3 {c |}{res}          1    .6402439           .   .6402439   .6402439
{txt}{space 5}p_Fla_4 {c |}{res}          1    .7743902           .   .7743902   .7743902
{txt}{space 5}p_Fla_5 {c |}{res}          1    .6036586           .   .6036586   .6036586
{txt}{hline 13}{c +}{hline 57}
{space 5}p_Fla_6 {c |}{res}          1    .4878049           .   .4878049   .4878049
{txt}{space 5}p_Fla_7 {c |}{res}          1    .3719512           .   .3719512   .3719512
{txt}{space 5}p_Fla_8 {c |}{res}          1    .2317073           .   .2317073   .2317073
{txt}{space 5}p_Fla_9 {c |}{res}          1    .4878049           .   .4878049   .4878049
{txt}{space 4}p_Fla_10 {c |}{res}          1    .4756097           .   .4756097   .4756097
{txt}
{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\tablea3.do"
{txt}
{com}. *TABLE A3
. *PANEL A
. *Childcare
. use synth3_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    4.869585    .7184044   3.689182   5.995292
{txt}_Y_synthetic {c |}{res}         16     5.96227    .9499241    4.73052   8.344757
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 3 in Table A2 (see tablea2.do)
. 
. *Education
. use synthed9_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    18.76759    2.566832   15.19656   23.22392
{txt}_Y_synthetic {c |}{res}         16    20.34376    3.344936   16.23728   28.26171
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 9 in Table A2 (see tablea2.do)
. 
. *Elderlycare
. use synthel9_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    26.96141    3.478528   23.48755   33.15353
{txt}_Y_synthetic {c |}{res}         16    30.96104    2.175669   27.72525   36.68919
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 9 in Table A2 (see tablea2.do)
. 
. *Health care
. use synthhe3_615.dta, clear
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    11.96166    2.859327   7.099644   17.66421
{txt}_Y_synthetic {c |}{res}         16    9.685987     1.92627   6.799723   13.26752
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value is from Model 3 in Table A2 (see tablea2.do)
. 
. 
. *PANEL B
. *Childcare
. use synth1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 3 4 9 10{c -(}
{txt}  2{com}. append using synth`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995  

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    4.869585    .7184044   3.689182   5.995292
{txt}_Y_synthetic {c |}{res}         16     6.66037    1.107861   4.884989   8.878531
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "childcare_avg_p_long.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .4146341           .   .4146341   .4146341
{txt}
{com}. 
. *Education
. use synthed1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 3  5 6 7 8  9 10{c -(}
{txt}  2{com}. append using synthed`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995  

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    18.76759    2.566832   15.19656   23.22392
{txt}_Y_synthetic {c |}{res}         16    20.56007    2.814296    17.2365     27.277
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "education_avg_p_long.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .2439024           .   .2439024   .2439024
{txt}
{com}. 
. 
. *Elderlycare
. use synthel1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 7 8 9 10{c -(}
{txt}  2{com}. append using synthel`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995  

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    26.96141    3.478528   23.48755   33.15353
{txt}_Y_synthetic {c |}{res}         16    30.86961    1.964971   27.99422   36.09584
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "elderly_avg_p_long.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .4878049           .   .4878049   .4878049
{txt}
{com}. 
. 
. *Health care
. use synthhe1_615.dta, clear
{txt}
{com}. foreach t of numlist 2 3  5 6 7 8  9 10{c -(}
{txt}  2{com}. append using synthhe`t'_615.dta
{txt}  3{com}. {c )-}
{txt}
{com}. collapse (mean) _Y_treated _Y_synthetic, by(_time)
{txt}
{com}. *Average Flå is mean _Y_treated, average synthetic control is mean _Y_synthetic
. su _Y_treated _Y_synthetic if _time>1995  

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}_Y_treated {c |}{res}         16    11.96166    2.859327   7.099644   17.66421
{txt}_Y_synthetic {c |}{res}         16     9.43069    1.503434     7.4134   11.34468
{txt}
{com}. *Difference is _Y_treated -_Y_synthetic
. *p-value: mean of p_Fla
. clear
{txt}
{com}. use "health_avg_p_long.dta"
{txt}
{com}. collapse (mean) RMSPE, by(komnr)
{txt}
{com}. gen RMSPE_Fla  = r(mean)
{txt}(164 missing values generated)

{com}. egen rank_RMSPE  = rank(-RMSPE) 
{txt}
{com}. gen rank_RMSPE_Fla =rank_RMSPE  if komnr==615  
{txt}(163 missing values generated)

{com}. gen p_Fla  = rank_RMSPE_Fla /164
{txt}(163 missing values generated)

{com}. su p_Fla 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}p_Fla {c |}{res}          1    .5365854           .   .5365854   .5365854
{txt}
{com}. 
{txt}end of do-file

{com}. do "L:\global vam\replication_psrm\tablea4.do"
{txt}
{com}. *TABLE A4
. *_Co_Number refers to Statistics Norway's municipality code. See complete list at https://no.wikipedia.org/wiki/Liste_over_norske_kommunenummer
. *Childcare (short run)
. clear
{txt}
{com}. use synth9_615.dta
{txt}
{com}. g negw = -_W_Weight
{txt}
{com}. sort negw
{txt}
{com}. format _W_Weight %9.2fc
{txt}
{com}. list _Co_Number _W_Weight if _W_Weight>0
{txt}
     {c TLC}{hline 10}{c -}{hline 10}{c TRC}
     {c |} {res}_Co_Nu~r   _W_Wei~t {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  1. {c |} {res}     511       0.37 {txt}{c |}
  2. {c |} {res}    1711       0.31 {txt}{c |}
  3. {c |} {res}     543       0.09 {txt}{c |}
  4. {c |} {res}     540       0.08 {txt}{c |}
  5. {c |} {res}     941       0.06 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  6. {c |} {res}    2015       0.03 {txt}{c |}
  7. {c |} {res}     432       0.03 {txt}{c |}
  8. {c |} {res}    1924       0.03 {txt}{c |}
  9. {c |} {res}    1545       0.01 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 10}{c BRC}

{com}. 
. *Childcare (long run)
. clear
{txt}
{com}. use synth3_615.dta
{txt}
{com}. g negw = -_W_Weight
{txt}
{com}. sort negw
{txt}
{com}. format _W_Weight %9.2fc
{txt}
{com}. list _Co_Number _W_Weight if _W_Weight>0
{txt}
     {c TLC}{hline 10}{c -}{hline 10}{c TRC}
     {c |} {res}_Co_Nu~r   _W_Wei~t {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  1. {c |} {res}    1711       0.34 {txt}{c |}
  2. {c |} {res}     941       0.22 {txt}{c |}
  3. {c |} {res}    2015       0.09 {txt}{c |}
  4. {c |} {res}    1755       0.08 {txt}{c |}
  5. {c |} {res}     540       0.07 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  6. {c |} {res}    1252       0.07 {txt}{c |}
  7. {c |} {res}    1412       0.06 {txt}{c |}
  8. {c |} {res}     543       0.05 {txt}{c |}
  9. {c |} {res}    2028       0.02 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 10}{c BRC}

{com}. 
. *Education
. clear
{txt}
{com}. use synthed9_615.dta 
{txt}
{com}. g negw = -_W_Weight
{txt}
{com}. sort negw
{txt}
{com}. format _W_Weight %9.2fc
{txt}
{com}. list _Co_Number _W_Weight if _W_Weight>0
{txt}
     {c TLC}{hline 10}{c -}{hline 10}{c TRC}
     {c |} {res}_Co_Nu~r   _W_Wei~t {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  1. {c |} {res}     940       0.51 {txt}{c |}
  2. {c |} {res}     830       0.31 {txt}{c |}
  3. {c |} {res}    1252       0.07 {txt}{c |}
  4. {c |} {res}    1567       0.06 {txt}{c |}
  5. {c |} {res}    1026       0.04 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  6. {c |} {res}    1835       0.02 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 10}{c BRC}

{com}. 
. *Elderlycare
. clear
{txt}
{com}. use synthel9_615.dta, clear
{txt}
{com}. g negw = -_W_Weight
{txt}
{com}. sort negw
{txt}
{com}. format _W_Weight %9.2fc
{txt}
{com}. list _Co_Number _W_Weight if _W_Weight>0
{txt}
     {c TLC}{hline 10}{c -}{hline 10}{c TRC}
     {c |} {res}_Co_Nu~r   _W_Wei~t {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  1. {c |} {res}    1411       0.27 {txt}{c |}
  2. {c |} {res}    1739       0.23 {txt}{c |}
  3. {c |} {res}     541       0.11 {txt}{c |}
  4. {c |} {res}    1144       0.10 {txt}{c |}
  5. {c |} {res}     430       0.08 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  6. {c |} {res}     432       0.07 {txt}{c |}
  7. {c |} {res}    1749       0.07 {txt}{c |}
  8. {c |} {res}    1815       0.03 {txt}{c |}
  9. {c |} {res}    1856       0.03 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 10}{c BRC}

{com}. 
. *Health care
. clear
{txt}
{com}. use synthhe3_615.dta, clear
{txt}
{com}. g negw = -_W_Weight
{txt}
{com}. sort negw
{txt}
{com}. format _W_Weight %9.2fc
{txt}
{com}. list _Co_Number _W_Weight if _W_Weight>0
{txt}
     {c TLC}{hline 10}{c -}{hline 10}{c TRC}
     {c |} {res}_Co_Nu~r   _W_Wei~t {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  1. {c |} {res}     432       0.53 {txt}{c |}
  2. {c |} {res}    1665       0.25 {txt}{c |}
  3. {c |} {res}    1144       0.14 {txt}{c |}
  4. {c |} {res}     941       0.05 {txt}{c |}
  5. {c |} {res}    1151       0.02 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c RT}
  6. {c |} {res}    2027       0.00 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 10}{c BRC}

{com}. 
{txt}end of do-file

{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}L:\global vam\replication_psrm\replication.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}26 Apr 2019, 18:48:23
{txt}{.-}
{smcl}
{txt}{sf}{ul off}